create external table jms_dm.dm_tiktok_data_dt (
      taking_date date comment '日期',
      start_subordinate_agent_code string comment '寄件代理区编码',
      start_parent_network_code string comment '始发加盟商code',
      start_pick_network_code string comment '始发网点code',
      start_subordinate_agent_name string comment '寄件代理区',
      start_parent_network_name string comment '始发加盟商name',
      start_pick_network_name string comment '始发网点name',
      taking_num int comment '收件量',
      is_land_rate double comment '桃花岛占比',
      is_land_num int comment '桃花岛量',
      is_dy_rate double comment '抖音占比',
      is_dy_num int comment '抖音量',
      is_ks_rate double comment '快手占比',
      is_ks_num int comment '快手量',
      other_rate double comment '其它占比',
      other_num int comment '其它量')
    COMMENT '抖音快手查询表'
    PARTITIONED BY (
         dt         STRING COMMENT '更新日期 (yyyy-MM-dd)')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_tiktok_data_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );
